﻿CREATE TABLE [dbo].[Users] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [UserNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserName] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserLevel] int  NULL,
  [Password] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO
-- ----------------------------
-- Primary Key structure for table Users
-- ----------------------------
ALTER TABLE [dbo].[Users] ADD CONSTRAINT [PK__Users__3214EC07CD638033] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]